create proc SuaDonDatHang (@id int,@tenkh nvarchar(250),@tenmh nvarchar(250),@soluong char(20),@ngaydat date,@ngaygiao date)
as
begin
  update QL_DONDATHANG Set
  SOLUONG=@soluong,NGAYDATHANG=@ngaydat,
  NGAYGIAOHANG=@ngaygiao,
  TEN_KHACHHANG=@tenkh,TEN_MATHANG=@tenmh
  where ID_DONHANG=@id

end